Power BI Project For Beginners | Sales Insights Data Analysis Project - 2 - Data Discovery

codebasics · Beginner ·📊 Data Analytics & Business Intelligence ·5y ago
In this video we will cover project planning and data discovery aspect of our sales insights data analysis project. Once sales directory of atliQ hardware has decided to invest in data analysis project he will do a meeting with IT director, data analytics team to come up with a plan. They will use AIMS grid to define purpose and success criteria of this project. AIMS grid simple explanation:https://www.youtube.com/watch?v=6118I9HViuQ Once AIMS grid is defined, next step is data discovery. In this step, data analyst team approaches IT team within an organization who owns software system that keep track of sales records. These records are stored in mysql database. Power BI can be plugged to this database to pull necessary information required for data analysis. I also discuss ETL, OLTP, OLAP and data warehouse concepts. Many times we need separate data warehouse or OLAP system to run our data analytics queries but in our project we will directly use mysql database. Previous video: https://www.youtube.com/watch?v=hhZ62IlTxYs&list=PLeo1K3hjS3utcb9nKtanhcn8jd2E0Hp9b Next video: https://www.youtube.com/watch?v=JOrhcV3_NAk&list=PLeo1K3hjS3utcb9nKtanhcn8jd2E0Hp9b&index=3 How to learn data analyst skills for free: https://youtu.be/x6tnVOn4st4 Machine learning tutorial playlist: https://www.youtube.com/watch?v=gmvvaobm7eQ&list=PLeo1K3hjS3uvCeTYTeyfe0-rN5r8zn9rw Entire playlist for this project: https://www.youtube.com/playlist?list=PLeo1K3hjS3uva8pk1FI3iK9kCOKQdz1I9 Special thanks to my friend, Hemanand Vadivel (https://www.linkedin.com/in/hemanand-vadivel-0b34aab5/) who is an experienced data analyst manager working for a company in UK. He has a major contribution in this project. Basics of DAX & Data Modelling are the two fundamental technical skills required to author Power BI reports – There are the free courses I recommend from SQLBI.com DAX: https://www.sqlbi.com/p/introducing-dax-video-course/ Data Modelling: https://www.sqlbi.com/p/introduction-t
Watch on YouTube ↗ (saves to browser)
Sign in to unlock AI tutor explanation · ⚡30

Playlist

Uploads from codebasics · codebasics · 0 of 60

← Previous Next →
1 Python Tutorial - 1. Install python on windows
Python Tutorial - 1. Install python on windows
codebasics
 2 Python Tutorial - 2. Variables
Python Tutorial - 2. Variables
codebasics
 3 Python Tutorial - 3. Numbers
Python Tutorial - 3. Numbers
codebasics
 4 Python Tutorial - 4. Strings
Python Tutorial - 4. Strings
codebasics
 5 Python Tutorial - 5. Lists
Python Tutorial - 5. Lists
codebasics
 6 Python Tutorial - 6. Install PyCharm on Windows
Python Tutorial - 6. Install PyCharm on Windows
codebasics
 7 PyCharm Tutorial - 7. Debug python code using PyCharm
PyCharm Tutorial - 7. Debug python code using PyCharm
codebasics
 8 Python Tutorial - 8. If Statement
Python Tutorial - 8. If Statement
codebasics
 9 Python Tutorial - 9. For loop
Python Tutorial - 9. For loop
codebasics
 10 Python Tutorial - 10. Functions
Python Tutorial - 10. Functions
codebasics
 11 Python Tutorial - 11. Dictionaries and Tuples
Python Tutorial - 11. Dictionaries and Tuples
codebasics
 12 Python Tutorial - 12. Modules
Python Tutorial - 12. Modules
codebasics
 13 Python Tutorial - 13. Reading/Writing Files
Python Tutorial - 13. Reading/Writing Files
codebasics
 14 How to install Julia on Windows
How to install Julia on Windows
codebasics
 15 Python Tutorial - 14. Working With JSON
Python Tutorial - 14. Working With JSON
codebasics
 16 Julia Tutorial - 1. Variables
Julia Tutorial - 1. Variables
codebasics
 17 Julia Tutorial - 2. Numbers
Julia Tutorial - 2. Numbers
codebasics
 18 Python Tutorial - 15. if __name__ == "__main__"
Python Tutorial - 15. if __name__ == "__main__"
codebasics
 19 Julia Tutorial - Why Should I Learn Julia Programming Language
Julia Tutorial - Why Should I Learn Julia Programming Language
codebasics
 20 Python Tutorial - 16. Exception Handling
Python Tutorial - 16. Exception Handling
codebasics
 21 Julia Tutorial - 3. Complex and Rational Numbers
Julia Tutorial - 3. Complex and Rational Numbers
codebasics
 22 Julia Tutorial - 4. Strings
Julia Tutorial - 4. Strings
codebasics
 23 Python Tutorial - 17. Class and Objects
Python Tutorial - 17. Class and Objects
codebasics
 24 Julia Tutorial - 5. Functions
Julia Tutorial - 5. Functions
codebasics
 25 Julia Tutorial - 6. If Statement and Ternary Operator
Julia Tutorial - 6. If Statement and Ternary Operator
codebasics
 26 Julia Tutorial - 7. For While Loop
Julia Tutorial - 7. For While Loop
codebasics
 27 Python Tutorial - 18. Inheritance
Python Tutorial - 18. Inheritance
codebasics
 28 Julia Tutorial - 8. begin and (;) Compound Expressions
Julia Tutorial - 8. begin and (;) Compound Expressions
codebasics
 29 Python Tutorial - 12.1 - Install Python Module (using pip)
Python Tutorial - 12.1 - Install Python Module (using pip)
codebasics
 30 Julia Tutorial - 9. Tasks (a.k.a. Generators or Coroutines)
Julia Tutorial - 9. Tasks (a.k.a. Generators or Coroutines)
codebasics
 31 Julia Tutorial - 10. Exception Handling
Julia Tutorial - 10. Exception Handling
codebasics
 32 Python Tutorial - 19. Multiple Inheritance
Python Tutorial - 19. Multiple Inheritance
codebasics
 33 Python Tutorial - 20. Raise Exception And Finally
Python Tutorial - 20. Raise Exception And Finally
codebasics
 34 Python Tutorial - 21. Iterators
Python Tutorial - 21. Iterators
codebasics
 35 Python Tutorial - 22. Generators
Python Tutorial - 22. Generators
codebasics
 36 Python Tutorial - 23. List Set Dict Comprehensions
Python Tutorial - 23. List Set Dict Comprehensions
codebasics
 37 Python Tutorial - 24. Sets and Frozen Sets
Python Tutorial - 24. Sets and Frozen Sets
codebasics
 38 Python Tutorial - 25. Command line argument processing using argparse
Python Tutorial - 25. Command line argument processing using argparse
codebasics
 39 Debugging Tips - What is bug and debugging?
Debugging Tips - What is bug and debugging?
codebasics
 40 Debugging Tips - Conditional Breakpoint
Debugging Tips - Conditional Breakpoint
codebasics
 41 Debugging Tips - Watches and Call Stack
Debugging Tips - Watches and Call Stack
codebasics
 42 Python Tutorial - 26. Multithreading - Introduction
Python Tutorial - 26. Multithreading - Introduction
codebasics
 43 Git Tutorial 3: How To Install Git
Git Tutorial 3: How To Install Git
codebasics
 44 Git Tutorial 1: What is git / What is version control system?
Git Tutorial 1: What is git / What is version control system?
codebasics
 45 Git Tutorial 2 : What is Github? | github tutorial
Git Tutorial 2 : What is Github? | github tutorial
codebasics
 46 Git Tutorial 4: Basic Commands: add, commit, push
Git Tutorial 4: Basic Commands: add, commit, push
codebasics
 47 Git Tutorial 5: Undoing/Reverting/Resetting code changes
Git Tutorial 5: Undoing/Reverting/Resetting code changes
codebasics
 48 Git Tutorial 6: Branches (Create, Merge, Delete a branch)
Git Tutorial 6: Branches (Create, Merge, Delete a branch)
codebasics
 49 Git Github Tutorial 10: What is Pull Request?
Git Github Tutorial 10: What is Pull Request?
codebasics
 50 Git Tutorial 7: What is HEAD?
Git Tutorial 7: What is HEAD?
codebasics
 51 Git Tutorial 9: Diff and Merge using meld
Git Tutorial 9: Diff and Merge using meld
codebasics
 52 Difference between Multiprocessing and Multithreading
Difference between Multiprocessing and Multithreading
codebasics
 53 Python Tutorial - 27. Multiprocessing Introduction
Python Tutorial - 27. Multiprocessing Introduction
codebasics
 54 Python Tutorial - 28. Sharing Data Between Processes Using Array and Value
Python Tutorial - 28. Sharing Data Between Processes Using Array and Value
codebasics
 55 Git Tutorial 8 - .gitignore file
Git Tutorial 8 - .gitignore file
codebasics
 56 Python Tutorial - 29. Sharing Data Between Processes Using Multiprocessing Queue
Python Tutorial - 29. Sharing Data Between Processes Using Multiprocessing Queue
codebasics
 57 Python Tutorial - 30. Multiprocessing Lock
Python Tutorial - 30. Multiprocessing Lock
codebasics
 58 Python Tutorial - 31. Multiprocessing Pool (Map Reduce)
Python Tutorial - 31. Multiprocessing Pool (Map Reduce)
codebasics
 59 What is code?
What is code?
codebasics
 60 Python unit testing - pytest introduction
Python unit testing - pytest introduction
codebasics

Related AI Lessons

⚡
The Unexpected Benefits of Knowledge Hoarding: What Two Years with Papers Taught Me About Information Addiction
Discover the unexpected benefits of knowledge hoarding and how it can change your approach to information management
Dev.to AI
 ⚡
DFAS-RPG: Article 08 | Validation Governance: Separating Path Integrity from Outcomes
Learn to separate path integrity from outcomes in validation governance for Research Path Governance (DFAS-RPG)
Medium · Data Science
 ⚡
I Built an AI-powered Youth Intelligence Platform Dashboard to Track The Rate of Unemployment- Here…
Learn how to build an AI-powered dashboard to track youth unemployment rates using Python and data analytics, and discover insights from a real-world project in Kenya.
Medium · Python
 ⚡
ANÁLISE DE MOVIMENTAÇÃO DE EXPORTAÇÕES NOS PORTOS DO CEARÁ
Analyze export movement in Ceará ports using Python to understand the impact of cargo exports
Medium · Python
Up next
Foundations of Data Science and Statistical Methods
Coursera
Watch →