Course Description This course will discuss the responsibilities and functions of a data analyst. Which includes the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. This course will show how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI. Power BI is a member of the Power Platform. Power Apps is another component that enables everyone to build and use apps that connect to business data. This course will show you how to use the Power Apps visual to pass context-aware data to a canvas app, which updates in real-time as you make changes to your report. This will allow your app users to derive business insights and take actions from right within their Power BI reports and dashboards. This course will also include information on basic T-SQL query development. Ingest, clean, and transform data Model data for performance and scalability Design and create reports for data analysis Apply and perform advanced report analytics Manage and share report assets Create paginated reports in Power BI Embed Power Apps into Power BI Understand the similarities and differences between Transact-SQL and other computer languages. Write SELECT queries Query multiple tables Sort and filter data Instructor: James Ring-HowellCourse Video Content: 13 Hours 58 MinutesTest Questions: 75 Course Content Module 1 - Query Tools1.1 Course Introduction1.2 Intro to Management Studio1.3 Intro to command-line query toolsModule 2 - Introduction to T-SQL Querying2.1 Introducing T-SQL2.2 Understanding Sets2.3 Understanding the Logical Order of Operations in SELECT statementsModule 3 - Basic SELECT Queries3.1 Writing Simple SELECT Statements3.2 Eliminate Duplicates with DISTINCT3.3 Using Column and Table Aliases3.4 Write Simple CASE ExpressionsModule 4 - Querying Multiple Tables4.1 Understanding Joins4.2 Querying with Inner Joins4.3 Querying with Outer Joins4.4 Querying with Cross Joins and Self JoinsModule 5 - Sorting and Filtering Data5.1 Sorting Data5.2 Filtering Data with Predicates5.3 Filtering with the TOP and OFFSET-FETCH5.4 Working with Unknown ValuesModule 6 - Introduction to Business Intelligence and Data Modeling6.1 Introduction to Business Intelligence6.2 The Microsoft Business Intelligence Platform6.3 Exploring a Data Warehouse6.4 Exploring a Data ModelModule 7 - Prepare Data7.1 Introduction to Power BI7.2 Get data from various data sources7.3 Preview source dataModule 8 - Clean, Transform, and Load Data8.1 Data Transformation Intro8.2 Transformation Example 18.3 Transformation Example 28.4 Transformation Example 38.5 Transformation Example 48.6 Transformation Example 58.7 Transformation Example 6Module 9 - Design a Data Model9.1 Introduction to Data Modeling9.2 Model Relationships9.3 Table Configuration9.4 Model interface9.5 Quick Measures9.6 Many-to-many relationships9.7 Row-level securityModule 10 - Create Model Calculations using DAX10.1 DAX context10.2 Calculated Tables10.3 Calculated Columns10.4 Managing Date Tables10.5 Measures10.6 Filter Manipulation10.7 Time IntelligenceModule 11 - Create Reports11.1 Basic Report Creation11.2 Example Page 111.3 Example Page 211.4 Example Page 311.5 Report Publishing11.6 Enhancing Reports11.7 Drill-Through Pages11.8 Conditional Formatting11.9 Buttons and BookmarksModule 12 - Create Dashboards12.1 Dashboard Basics12.2 Real Time Dashboards12.3 Enhanced DashboardsModule 13 - Create Paginated Reports13.1 Introduction to Power BI Report Builder13.2 Report Layouts13.3 Report Data13.4 Report TablesModule 14 - Perform Advanced Analytics14.1 Introduction to Advanced Analytics14.2 Scatter Chart14.3 Forecast14.4 Decomposition Tree14.5 Key InfluencersModule 15 - Create and Manage Workspaces15.1 Introduction to Workspaces15.2 Working with Workspaces and the PortalModule 16 - Create Power App Visuals16.1 Introduction to Power Apps Visual16.2 Creating the App16.3 Basic Power Apps Concepts16.4 Refreshing the ReportModule 17 - Analysis Services and Power BI17.1 Introduction to Analysis Services17.2 Connecting with Multidimensional Models17.3 Premium Workspaces and Analysis Services17.4 Course Wrap Up LEARN365 Courses Include 12 Months Unlimited Online Access to: Expert Instructor-Led Training: Learn 365 uses only the industry’s finest instructors in the IT industry. They have a minimum of 15 years real-world experience and are subject matter experts in their fields. Unlike a live class, you can fast-forward, repeat or rewind all your lectures. This creates a personal learning experience and gives you all the benefit of hands-on training with the flexibility of doing it around your schedule 24/7. Visual Demonstrations andamp; Multimedia Presentations: Our courseware includes instructor-led demonstrations and visual presentations that allow students to develop their skills based on real world scenarios explained by the instructor. Learn 365 always focuses on real world scenarios and skill-set development. Quizzes andamp; Exam Simulators: Learn 365’s custom practice exams prepare you for your exams differently and more effectively than the traditional exam preps on the market. You will have practice quizzes after each module to ensure you are confident on the topic you have completed before proceeding. This will allow you to gauge your effectiveness before moving to the next module in your course. Learn 365 courses also include practice exams designed to replicate and mirror the environment in the testing center. These exams are on average 100 questions to ensure you are 100% prepared before taking your certification exam. Navigation and Controls: Learn 365’s self-paced training programs are designed in a modular fashion to allow you the flexibility to work with expert level instruction anytime 24/7. All courses are arranged in defined sections with navigation controls allowing you to control the pace of your training. This allows students to learn at their own pace around their schedule. Certificate of Completion: Upon completion of your training course, you will receive a Certificate of completion displaying your full name, course completed as well as the date of completion. You can print this out or save it digitally to showcase your accomplishment. Need to train your Team? Contact Us for Discounts on Multiple Subscription Purchases.
