Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA CompTIA Security+ Amazon AWS AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Business Business Analytics & Intelligence Microsoft PowerApps

Revealed: Data Consolidations with Microsoft Power BI Tools

All The Power BI Consolidation Secrets Microsoft Was Supposed To Show You, But Never Did
Rating: 4.2 out of 54.2 (14 ratings)
92 students
Created by Doug Burke
Last updated 1/2019
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Use the power of Excel 2016, Power Query and Power Pivot to create structure, reduce complexity, and improve flexibility
  • Creating a systems-based approach to data transformations
  • Consolidating data between multiple business entities
  • Data transformations using Microsoft Excel, Power Query, and Power Pivot
  • Learn to 'clean' your trial balance data and put into a format suitable for analysis
  • Managing the Data Model by creating relationships between data sets
  • Creating Dashboards to present the data using Visual Basic and simple macros
  • Course Layout: a.) Transforming the Data b.) Creating Dashboards c.) Making Decisions
  • Sample files are provided to follow along and test your understanding real-time
  • Apply these techniques to your organization

Requirements

  • Familiarity with Microsoft Excel
  • Knowledge of basic Finance and Accounting principals and understand the difference between an Income Statement and a Balance Sheet
  • A strong desire to harness the power of Power Query, Power Pivot and Power BI

Description

This course will teach you how to systematically transform and consolidate financial data using Microsoft Excel, Power Query, and Power Pivot. I will show you how to turn your organization's existing Trial Balance into a meaningful query that can easily be replicated each time you regenerate your data. We will construct relationships in the data model, allowing us to turn the initial Trial Balance into a Global Income Statement by connecting data across multiple entities.

My guarantee to you:

After taking this course you'll learn a new way to use Power BI products to manage financial consolidations.

Does your financial close process suffer from any of these common ailments?

  • Unstructured - No commonality in account structure? No corporate hierarchies for dimensions such as accounts, entities, departments and products?

  • Complex - Use of multiple spreadsheets for consolidation? Poor controls, no process standardization and limited communication between users?

  • Inflexible - Lack of multidimensional financial reporting that can quickly adapt to changing business needs?

Use the power of Excel 2016, Power Query, Power Pivot and the Data Model to solve these problems.

  • Create structure - define a common chart of accounts and reporting dimensions shared by all locations, departments and reports

  • Reduce complexity - dramatically improve controls by having 'one version of the truth' accessible to multiple users; eliminate need for multiple spreadsheets while communicating close status to all users throughout the process

  • Introduce flexibility - create updatable multidimensional hierarchy structures that quickly meet accounting and Finance reporting requirements

Become the financial systems superstar at your current company or go somewhere else and be their superstar.

Who this course is for:

  • Finance and Accounting professionals who perform data transformations and consolidations
  • All financial analysts who need a better way to handle large amounts of data
  • Those who want to improve or eliminate their manual, error-prone spreadsheet data transformations and replace with a simpler, more reliable system
  • Those who want to improve their data analytics and Power Query talents

Course content

7 sections • 30 lectures • 3h 28m total length

  • Preview03:40
  • Download the Sample Files
    01:21
  • Hello, World!
    09:33

  • Purpose of This Section
    00:33
  • Section 1, Lesson 01 - Load metadata - Chart of Accounts (Power Query)
    10:00
  • Section 1, Lesson 02 -Load metadata - Chart of Accounts (Power Query)
    07:55
  • Preview10:45
  • Analyze data (Power Pivot)
    08:43
  • Learn By Doing - Build your Financial Consolidations Data Section
    02:04

  • Purpose of This Section
    02:10
  • Preview07:55
  • Section 2, Lesson 02 - Add Navigation Macros
    10:42
  • Section 2, Lesson 03 - Refresh the Dashboard
    05:11
  • Section 2, Lesson 04 - Clean Up the Dashboard
    13:27
  • Learn By Doing - Let's build a Financial Consolidations Dashboard
    01:41

  • Purpose of This Section
    00:17
  • Section 3, Lesson 01 - Data Cleaning your Power Pivot Reports
    10:39
  • Preview06:30
  • Section 3, Lesson 03 - Hiding Report Member Names
    04:28
  • Section 3, Lesson 04 - Adding Report Data Columns
    12:41
  • Learn By Doing - Build your Financial Consolidations Report
    02:03

  • Purpose of This Section
    02:46
  • Section 4, Lesson 01 - Create an Income Statement
    12:03
  • Section 4, Lesson 02 - Data Load for a Second Legal Entity
    14:25
  • Section 4, Lesson 03 - Combining Income Statements (E01 and E02)
    14:51
  • Section 4, Lesson 04 - Global Income Statement
    14:29

  • Section 5, Lesson 1 - Add a Dashboard Text Box
    06:28
  • Section 5, Lesson 2 - Fix Broken Dashboard Links
    10:32

  • BONUS - - Congratulations! Some Further Resources and Contact Information
    00:30
  • Please Rate and Review
    00:24

Instructor

Doug Burke
Financial Systems Leader and Experienced Teacher
Doug Burke
  • 4.1 Instructor Rating
  • 352 Reviews
  • 8,323 Students
  • 5 Courses

If you're like me, you see tremendous value in developing your career in data analytics, business intelligence and creating financial systems. Companies need these skills more than ever.

But did you know  . . . 

 ** The hardest part of any useful business intelligence system is getting clean data **

This statement comes from my 20+ years of experience building data analytics systems at Fortune 500 companies. Let me share my secrets so you get much better at cleaning your analytics data for better financial systems.

____________________________________________________________________

My specialty is creating clean data using Excel Power Query and Power BI Query Editor for analysis and visualizations.  

I love this topic . . . Learn from me.  

> I read the software user manuals so you don't have to

> I enjoy teaching complex topics in a clear, simple manner

> I'm very involved in the analytics community as a member of Microsoft's Power BI User Panel, and a frequent speaker at Oracle analytics events 

Courses like mine are not widely available so I decided to create one. Thanks to the internet, a global audience now shares this knowledge.

Take my courses and enter a community of like-minded people who want everyone to succeed.  I will personally answer any question posted and provide frequent updates on what's happening in the Power Query and Power BI communities.  There is so much value here and I encourage you to join.

____________________________________________________________________

** You can dramatically improve your data cleaning skills today ** 

What are you waiting for?

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.