课程详情

Description**** Life time access to course materials. 100% money back guarantee ****Companies are gathering more and more data everyday. Skills in data analysis, Business Intelligence / Business Analytics are highly in demand in today's job market. Microsoft Power BI is an advanced yet easy to use self service Business Intelligence / Business Analytics tool for that. It is same B.I. tools used by professional analysts and data scientists.In this course together we will go over business scenarios where you will learn, how to use Power BI and advanced / complex DAX calculations further to derive more insights from data. We are using SQL Server Adventure Works Data warehouse as a sample database. We will hold your hand and walk you thru each scenario Step-by-step.Not only you will learn Power BI Best Practices, Tip, Tricks and Case Studies that you won't find in ANY other course but also learn Microsoft's Popular Course DASHBOARD-IN-A-DAY at your own pace at home or at your office AS A BONUS. All of the exercises are designed by keeping the practical aspects of Power BI and DAX in mind. All exercises are 100% hands-on.25+ hours of HD videos of building Business Scenarios using DAX and 10 interactive Business Intelligence Reports and Dashboards from scratch to finish. Files for Start and Finished projects also included to challenge you so you can learn by immediately applying what you're learning. You will have gained the knowledge and confidence to apply these same concepts to real-word to solve the Business problems or Business requirements.By the time you complete this course, You'll be a highly proficient in DAX and Power BI user. You'll be fully prepared to collect, clean, model and present data for any purpose. You will be using your skills as a Business Intelligence Professional to extract knowledge from data so you can analyze and visualize complex Business Problems/Requirements with ease.Why should you consider a career as a Business Data Analyst?Salary. A Business Data Analyst is a well-paid careerStable Career. As most corporations gathering more and more data. There will never be shortage of Jobs for Business Data Analyst.Advancement in Career: Since you will be building different reports for different departments. You will never be bored and always be valued. Which will bring you more opportunities in your career. Business Data Analyst get very visibility in corporations. Whole management depends on them.#microsoft #powerbi #data #business #intelligence #analysis #DAXWe are covering the following in this course.Section 1: Advanced Microsoft Power BI IntroductionAdvanced Microsoft Power BI Course IntroductionWhy Microsoft Power BIMicrosoft Power BI FamilyMicrosoft Power BI DesktopMicrosoft Power BI Service (Cloud) 1Microsoft Power BI Service (Cloud) 2What is Descriptive, Predictive and Prescriptive AnalyticsHow to take the quizzesSection 2: Advanced Microsoft Power BI - Collect , In-jest and Import DataImport Data from CSV files in MicrosoftImport Data from Excel files in Microsoft Power BI DesktopImport Real-time Streaming Data in Microsoft Power BI Service (Cloud)Import Data from OData Feed REST-API inMicrosoft Power BI DesktopImport Data from Folders in Microsoft Power BI DesktopSection 3: Download and Install SQL Server and Sample DatabasesDownload and Install SQL ServerDownload and Install Sample DatabaseImport Data from SQL Server in Microsoft Power BI DesktopSection 4: Introduction to Power BI DataflowsPower BI Dataflows - IntroductionPower BI Dataflows - Create Gateway from ScratchPower BI Dataflows - Create Entities from CSV filePower BI Dataflows - Create Entities using SQL ServerSection 5: Introduction to Data ModelingModeling Basics 0Modeling Basics 1Modeling Basics 2Modeling and Relationships 0Modeling and Relationships 1Other ways to create RelationshipsNormalization - Denationalization 0Normalization - Denationalization 1OLTP vs OLAPStar Schema vs Snowflake Schema 0Star Schema vs Snowflake Schema 1Section 6: DAX BasicsDAX Basics - Importing Data for Dax LearningDAX Basics - Resources for Dax LearningDAX Basics - What is DaxDAX Basics - Dax Data TypesDAX Basics - DAX Operators and SyntaxDAX Basics - M vs DaxDAX Basics - Create a ColumnDAX Basics - Rules to Create MeasuresDAX Basics - Calculated Columns vs Calculated Measures-0DAX Basics - Calculated Columns vs Calculated Measures-1DAX Basics - Sum()DAX Basics - AVERAGE()-MIN()-MAX()DAX Basics - SUMX()DAX Basics - DIVIDE()DAX Basics - COUNT()-COUNTROWS()DAX Basics - CALCULATE()-0DAX Basics - CALCULATE()-1DAX Basics - FILTER()DAX Basics - ALL()Section 7: Hands-on Real-word ProjectsProcurement Spend AnalysisProducts AnalysisRegional AnalysisIT Tickets AnalysisHuman Resources Analysis 1Human Resources Analysis 2Human Resources Analysis 3Financial AnalysisSales/Marketing AnalysisBank Demographic ReportSection 8: Personal - Enterprise Gateway On-Premises GatewayPersonal vs Enterprise GatewayInstall and Configure Personal GatewayInstall and Configure Enterprise GatewayManage SQL Server Data Source thru Enterprise GatewaySection 9: Advanced Time-IntelligenceCreate Date Table in DAX-0Create Date Table in DAX-1Dax Date CodeCreate Date Table in M (important) 11minDate Table Code in MHow to use PREVIOUS FunctionHow to use SAMEPERIODLASTYEAR FunctionHow to calculate Cumulative or Running totals TOTALXXX()How to use DATEADD FunctionHow to add column DateLastPurchase in Customer TableHow to calculate Days to Ship and Delivery StatusHow to calculate Spring-Summer-Autumn-Winter Sales for 2012How to Calculate Customer Age and use it in charts and graphsHow to calculate Days till last purchaseHow to calculate Month-Over-Month valuesHow to calculate Previous Week SalesHow to calculate Running Total 1How to calculate Running Total 2How to calculate sales for last N daysHow to calculate Weekend - Weekday sales 1How to calculate Weekend - Weekday sales 2How to calculate Year-Over-Year GrowthHow to calculate Year-To-Date with Different Fiscal YearHow to Calulate Thanksgiving-BlackFriday-CyberMonday 2 we…How to compare Quarter over Quarter 01How to compare Quarter over Quarter 02How to compare Years-Quarters-Month better wayHow to create Short Month Name for Fiscal YearHow to do Grouping and Segmenting 1How to do Grouping and Segmenting 2How to use specific relationships if you have more than 1 relationshipDAX - Quick MeasuresDisplay Last Refresh DateSection 10: Advanced ScenariosCreate new table for Scenarios MeasuresHow to calculate number of order per customersHow to add calculated column in Employee tableHow to add calculated column in Resellers tableHow to calculate Customers (using TOPN) for Target MarketingHow to calculate and display Profit MarginsHow to calculate and display sales growthHow to calculate how many items bought by Customers Multple timesHow to calculate how many Resellers sold specific Item more than 5 timesHow to calculate Moving Average 1How to calculate Moving Average 2How to calculate number of Products - Customers Sales TrendHow to calculate Profit or Margin Variance Month-Over-MonthHow to calculate Trend on Profit for Internet SalesHow to categorize Employees on SalesHow to categorize Re-sellersHow to create Product SegmentHow to export measures from Power BI fileHow to see top N Products 01 StaticallyHow to see top N Products 02 DynamicallyHow to calculate and show ProfitsHow to calculate Best Product Sales DayHow to calculate Dynamic TOPN product or CustomersHow to calculate Hot Selling ProductsHow to calculate how many unique Customers bought specific ProductHow to calculate how many unique Products bought by each CustomerHow to calculate product sales growthHow to calculate Re-seller 01 Sales Growth Year-Over-YearHow to calculate Re-seller 02 Sales Growth Year-Over-YearHow to calculate Revenue Forecast using Analytics TabHow to calculate Revenue Forecast using What If ParameterHow to calculate Top EmployeesHow to calculate which Re-seller selling what ProductsHow to show Products quantity forecast using Analytics TabHow to show Products quantity forecast using using What If ParameterHow to smooth the trend using Moving AveragesSection 11: Sharing and Collaboration in Power BISharing and CollaborationSharing DashboardsSharing WorkspacesSharing AppsPublish to webSection 12: Bonus - Power BI Best PracticesPower BI Best Practices 0Power BI Best Practices 1Power BI Best Practices 2Power BI Best Practices 3Power BI Best Practices 4Power BI Best Practices 5Section 13: Bonus - Dashboard-in-a-day (Same as actual Microsoft class)Power BI Dashboard-in-a-day class 0 - IntroductionPower BI Dashboard-in-a-day class 1 - Accessing DataPower BI Dashboard-in-a-day class 2 - Data PreparationPower BI Dashboard-in-a-day class 3 - Data PreparationPower BI Dashboard-in-a-day class 4 - Modeling and Data ExplorationPower BI Dashboard-in-a-day class 5 - Modeling and Data ExplorationPower BI Dashboard-in-a-day class 6 - Modeling and Data ExplorationPower BI Dashboard-in-a-day class 7 - Modeling and Data ExplorationPower BI Dashboard-in-a-day class 8 - Modeling and Data ExplorationPower BI Dashboard-in-a-day class 9 - VisualizationPower BI Dashboard-in-a-day class 10 - VisualizationPower BI Dashboard-in-a-day class 11 - Publishing ReportPower BI Dashboard-in-a-day class 12 - Creating DashboardsPower BI Dashboard-in-a-day class 13 - Creating DashboardsPower BI Dashboard-in-a-day class 14 - Creating DashboardsBest RegardsBiztics Team

课程标签

0人关注该课程

主题相关的课程