Go back
Power BI Step By Step Connecting To Data Sources Part 2(1st Edition)
Authors:
Grant Gamble
Cover Type:Hardcover
Condition:Used
In Stock
Shipment time
Expected shipping within 2 DaysPopular items with books
Access to 30 Million+ solutions
Free ✝
Ask 50 Questions from expert
AI-Powered Answers
✝ 7 days-trial
Total Price:
$0
List Price: $7.99
Savings: $7.99(100%)
Solution Manual Includes
Access to 30 Million+ solutions
Ask 50 Questions from expert
AI-Powered Answers
24/7 Tutor Help
Detailed solutions for Power BI Step By Step Connecting To Data Sources Part 2
Price:
$9.99
/month
Book details
ISBN: 1717866239, 978-1717866233
Book publisher: Independently published (July 22, 2018)
Get your hands on the best-selling book Power BI Step By Step Connecting To Data Sources Part 2 1st Edition for free. Feed your curiosity and let your imagination soar with the best stories coming out to you without hefty price tags. Browse SolutionInn to discover a treasure trove of fiction and non-fiction books where every page leads the reader to an undiscovered world. Start your literary adventure right away and also enjoy free shipping of these complimentary books to your door.
Book Summary: Self-Service Business IntelligencePower BI enables business users to interact with corporate information and to extract the reports and intel they need. Power BI allows users to access reports and dashboards using familiar tools and devices. Self-service BI has never been so user-friendly!The Microsoft Power BI Step-by-Step series will show you how to create compelling visualizations and reports which provide deep insights into your data.This first book in the series is designed to get you up and running with the three main components of Power BI:Power BI Desktopthe Power BI Serviceand Power BI Mobile Apps.What you will Learn from the Power BI Step-by-Step SeriesYou will learn how to connect to a wide variety of data sources, using both Power BI Desktop, and the Power BI Service.You will be able to use the Query Editor to transform and morph data into the right format for your reporting purposes.You will be able to perform complex data modelling operations using relationships, calculated columns, measures, and DAX expressions.You will learn how to share dashboards and reports, with colleagues, business partners and potential clients; and how to use Power BI’s sophisticated security features to control the exact content your audience is able to view.In short, the Power BI Step-by-Step series will equip you with all the skills you need to start using Power BI with confidence.Part 2: Connecting to Data SourcesThe aim of this second book in the series is explore Power BI data connections. However, these tutorials will also provide some further practice on report creation.IntroductionChapter 1: Connecting to Text FilesOverview of the Query EditorClosing and Reopening the Query Settings PaneRenaming a QueryUsing the Query Settings ButtonsApplying Changes Made in the Query EditorEditing an Existing QueryConclusionChapter 2: Connecting to Excel DataWorksheets, Tables and Name RangesImporting Excel Objects into Power BIRecognizing the IconsConclusionChapter 3: Connecting to a Folder of DataBenefits of Connecting to a FolderConnecting to the FolderUpdating the FolderConclusionChapter 4: Connecting to Web DataExamining the Source DataConnecting to the Excel DataConnecting to the Currency Exchange Rate DataQuery Editor: Remove ColumnsQuery Editor: Use First Row as HeadersQuery Editor: Filtering out Unwanted RowsQuery Editor: Renaming a QueryQuery Editor: Creating a Custom ColumnAdding a Report Background ImageAutomatic Detection of RelationshipsUsing the Table VisualCreating Calculated ColumnsUsing the Slicer VisualConclusionChapter 5: Connecting to SQL ServerGetting Set UpComparing the Database to the Data ModelImporting SQL Server ViewsAuthentication ModeEnhancing the Data ModelRefreshing Imported SQL Server DataImport Versus DirectQueryRefreshing DirectQuery SQL Server DataConnecting to Database Tables Using SQL StatementsLeveraging Query FoldingQuery Folding and Native QueriesMonitoring Query FoldingConclusionNext StepsG Com Solutions LimitedG Com Solutions Limited provide Power BI training in Peterborough, London and throughout the UK. Details of their Power BI courses can be found at the following URL:https://gcomsolutions.co.uk/microsoft-power-bi-training-courses/
Customers also bought these books
Frequently Bought Together
Top Reviews for Books
Request tk1l85m
( 5 )
"Delivery was considerably fast, and the book I received was in a good condition."