Ad-Hoc-Analysis
Atliq Hardwares (imaginary company) is one of the leading computer hardware producers in India and well expanded in other countries too.
However, the management noticed that they do not get enough insights to make quick and smart data-informed decisions. so they to conduct a SQL challenge or ad-hock requests which will help them to get better insights of company's performance.
SQL Script File : AnswersScript.SQL
StoreProcedures : StoreProcedures-AdHock-Questions.SQL
PowerBI File : Challenge-4-Atliq-Exclusive.pbix
DataSource : https://codebasics.io/challenge/codebasics-resume-project-challenge (goto challenge-4)
Raw-data file provided by @CodeBasics is for MySql, and I am more Familiar with MS-SQL.
So first, I create load database in MySql, then create new database in MS-SQL server and migrate data into it from MySql server using SSMA( SQL Server Migration Assistant) tool.
After that, I begin work on project, ad-hock-request one by one.
Then, For visualization I created StoreProcedures for Each requests in SQL, Import those SPs into PowerBI and create dashboard for each requests.
You can get Both Request and Answers (SQL Code) in "AnswersScript.SQL" as well as all store Procedures "StoreProcedures-AdHock-Questions.SQL" in above code section, and for all Raw files and challenge related info/files, kindly check codebasics website link I mentioned in DataSource above.
- Sample ScreenShot of "AnswersScript.SQL" file
- PowerBI Dashboard for all Ad-hock requests
