dhruvitmodi/sql-powerbi_atliq-hardware_codebasics_challenge_4

Ad-hock analysis of requests for HardWare company in MS SQL

SQL-PowerBI_Atliq-Hardware_CodeBasics_Challenge_4

Ad-Hoc-Analysis

Domain: Consumer Goods | Function: Executive Management

TASK : Provide Insights to Management in Consumer Goods Domain

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