The Curious Engineer

All blogs / Databases

avising

learn.microsoft.com/en-us/archive/blogs/avising

DatabasesDev tools / editors / IDEsMicrosoft blogsMSDN archive

’15’20’25
Posts
172 from 2 Sep 2014 to 29 Feb 2016
Posting
archived, read-only
Kind
company blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/avising/feed.xml

2016 14

  1. Power Query and Fixed-width M(agic)!
  2. Job Opportunities in Seattle Area!
  3. <REVIEW>List.Generate(): Create Tables from Thin Air in Power BI with M!
  4. Data Modeling for Power Pivot and Power BI
  5. Sort Your Data on Load for Improved Compression
  6. For Real This Time: Show Barnes & Noble that Power Pivot and Power BI are Important!
  7. Oh Em Gee: Embedded Power BI Dashboard, Google Analytics, Real-Time?
  8. Upcoming In-Person Class Schedule, March-May
  9. MS Roadmap: The Good, the Bad, and the Ugly
  10. B&N Does NOT Have the Books Yet + A CIA Story
  11. Show Barnes & Noble that Power Pivot is a Monster!
  12. Year to Date in Previous/Prior Year
  13. Start 2016 By Meeting Us at Upcoming Conferences!
  14. Restructure Your Data Table for Improved Compression

2015 122

  1. Holiday Gift! Print Edition Available & Signup for Free Book Discussion Webinar
  2. Quickbooks Analysis via QQube!
  3. Compression with Power Pivot
  4. BI for Everyone: Tear Down the Wall Between IT and Business
  5. Happy Thanksgiving! Enroll in our Online Course
  6. Break your DAX Problem into Manageable Parts
  7. Gear Up for Black Friday Sale at PowerPivotPro
  8. GFITW Strikes Again! Another Power Pivot Training Exercise
  9. 2nd Edition is Here: Get the eBook Today!
  10. Free Power BI Webinar on Tue Nov 17
  11. Foreword and Forward: Excerpt from Second Edition
  12. (SOLUTION) Real World Exercise using Power Pivot, Power Query
  13. The High Cost of Poor Equipment
  14. What Versions of Office 2016 Contain Power Pivot?
  15. Power BI at Beauty Pageant: An Exercise for Beginners
  16. Giving Back: “Steal” this Reference Card!
  17. Power Pivot, Power BI and Last Chances
  18. Power BI Sep 22 Webinar Recording and Signups
  19. Interview with Kamal Hathi of Microsoft, plus “AMA!”
  20. Bring Rob Home! Last Few Days to Preorder Power Pivot Book
  21. Facelift!
  22. Share and Refresh Power Query with Local Links
  23. Power BI / Power Pivot Class Date Change for Indy
  24. Mini Post #3: Cases of Books at 50% Off
  25. Mini-Post 2 of 3: Power BI Desktop Loads 2016 Files
  26. Mini-Post 1 of 3: We finally “sold out” to Microsoft
  27. Power BI and the Trajectory of Your Life
  28. Complex Customer Cohort Retention Using PRODUCTX
  29. Free Webinar: Excel to Power BI, Tue Sep 22 with a Special Guest
  30. Quick 1-question poll: heard of Alchemy?
  31. Power Query as an SSIS Alternative
  32. Some “Biz,” Then Reflection on Connection
  33. Power Pivot/Power BI Job Opportunity in Seattle Area
  34. Preorder 2nd Edition of our DAX Book, Help us Print in Color, Get Cool Perks :)
  35. Two Tricks to Make Your Cube Formula Scorecards Drama-Free!
  36. California Power Pivot / Power BI Pro for Hire
  37. Excel to Power BI Webinar Recording and a Call for Your Votes!
  38. Power BI Desktop Now Converts Power Pivot Workbooks
  39. Quick Poll on Data Nerd “Art”
  40. Power BI Desktop New Feature: Bi-Directional Relationships!
  41. Grab Bag: Job Opps, Sold Out in Indy, and a Vibrant Power BI Discussion
  42. Free Webinar: Excel to Power BI, Tue Aug 18
  43. Building Datazen Dashboards from Existing Power Pivot Models
  44. Transitioning from Excel Power Pivot/Query to Power BI Desktop: A Remarkably Smooth Road
  45. Nested SUMX or DAX Query?
  46. So Your Detailed/Flat Pivot is Slow and Doesn’t Sort Properly? Try Text Measures!
  47. Power BI Desktop (Designer) vs. Excel: Rematch
  48. Are Your Official Data Tools an “Arranged Marriage?”
  49. Webinar Recording and Online Class Aug 3-4
  50. Connecting to an Oracle Database from Power Pivot
  51. Excel 2016: Ten Heartwarming Improvements
  52. RANKX with Ascending Order to Show Lowest Quotes by Vendors
  53. Summer Fun at PowerPivotPro Free Webinar: Jul 22
  54. Consolidated Worksheets with Power Query
  55. Power BI Designer vs. Excel: What’s Microsoft Up To?
  56. Power Query Training: From Zero to [M]ax
  57. A Hello Heard Around the World
  58. 2-Day Class in Indianapolis, Aug 25-26
  59. Cycle Plots Show You Data Insights using Power Pivot
  60. Counting Overlapping/Shared Twitter, Facebook, Instagram, etc. Followers
  61. No More Apologies: Excel is the World’s Best Data Tool, Period.
  62. Time to revisit the Power Pivot Import Wizard
  63. RANKX-apalooza: Within and Across Groups, With Filters, Etc.
  64. Power BI Jun 2nd Webinar Recording Available
  65. Data Nirvana: Power Pivot, OData, and Acumatica ERP
  66. A New Take on “Data Quality?”
  67. Last Chance to register for Power BI Webinar, Tue Jun 2nd
  68. Dear Accountants: PowerPivot is your friend!
  69. Some Good Power Pivot / Power BI Computers
  70. Red Nose Day Special: 24 Distinctive Ways to Die
  71. <Draft>Dear Accountants: PowerPivot is your friend!
  72. Grab Bag of Fun
  73. Power Pivot Online Class Jun 8-9: Join the Party
  74. Power Query Super Charges the Internet
  75. Datazen = Beautiful Mobile Dashboards to Make Power Pivot Shine
  76. Free Webinar: How to Build BI Solution Using Power BI
  77. Harness Power Query to Gain Competitive Analysis Insights from LinkedIn
  78. Our Road Ahead
  79. Secret Pot Roast Recipe: Power Query vs. VBA Macros
  80. Where’s Rob?
  81. Just around the corner: May 4-5 Online Power Pivot Class
  82. VLOOKUP better than Relationships? Hell must have frozen over
  83. In-Person 2-Day Class, May 12-13, Cleveland
  84. Jump between pivots with context
  85. Is Your DAX/PowerPivot/Power BI Computer FAST?
  86. “Beta Test” the New Reference Card?
  87. Protecting time intelligence expressions against non-consecutive range of days
  88. The Diabolical Genius of “SWITCH TRUE”
  89. Best way to learn Power Pivot: get over analysis paralysis
  90. Power Pivot and Basketball Superstars: Many-to-Many and USERELATIONSHIP
  91. Power Update Adds Email Notifications, Macro Support, and 100% Free Version
  92. Course Prep: Excel 2010 and Excel 2013 Differences
  93. Create a 445 Calender using Power Query
  94. Thanks for attending the *beeping* webinar: Q&A From Webinar
  95. Schrodinger’s Pivot, or Why CALCULATE() Should Be Your Favorite Function EVER.
  96. Excel Users Everywhere: Free PowerPivot Webinar Tomorrow Tue Mar 17th
  97. Creating a Histogram with a User Defined Number of Buckets
  98. Listen to Me Interview MrExcel (Bill Jelen), and See Us Both at the PASS Biz Analytics Conference
  99. Excel to Power Pivot Webinar Countdown – in 10 days
  100. How to Compare the Current Row to the Previous Row in Power Pivot
  101. PowerPivotPro Expands to Europe/Africa/Asia, Welcomes Dany Hoter!
  102. Interview with Chris Finlan of Microsoft
  103. Power Pivot Blitzkrieg: Webinar, Seattle Class, Online Class
  104. Power Pivot to SSAS Tabular: Automatically Publish Excel Workbooks
  105. Create a Custom Calendar in Power Query
  106. Power Pivot to SSAS Tabular in less than 30 minutes
  107. Supporting Files from “Power Pivot Alchemy”
  108. Tales from the Trenches: My personal experience with Power Update (by Tim Rodman)
  109. Introducing Power Update!
  110. Upcoming Webinar at PASS BA Marathon Tue Feb 3rd
  111. Dynamic Age Calculation Using Measures
  112. Power BI, YouTube for Workbooks: More Affordable!
  113. Live Class, Online, Online U… Which is Right For You?
  114. SEA vs GB NFC Championship Game: Visualized in Power BI Dashboard
  115. The Only “Requirements Doc” You Will Ever Need
  116. Reminder: Webinar – Excel to Power Pivot Jan 20th (mini-post)
  117. Power Query for Excel: Combine multiple files of different file types
  118. Power BI as Google Docs Antidote
  119. PowerPivot Live Online Class in January and New Year Resolutions
  120. Cleveland and D.C. In-Person Classes in February!
  121. Would You Like to Join Our Team in 2015?
  122. Mini-Post: Excel to Power Pivot, Webinar Jan 2015

2014 36

  1. See You in 2015!
  2. Last Week’s Survey
  3. SQL Date Tables in Power Pivot
  4. Help Us Design Our 2015 In-Person Class Schedule!
  5. Repeat Customers in DAX: Three Flavors
  6. The Catalyst to Corporate Power Pivot Success
  7. Black/White Decisions in a Greyscale World
  8. Monday Mini-Post: Excel to Power Pivot Cross the Gap Webinar Dec 1st
  9. Flat to Star Transformation using DAX Query
  10. Visualization Layers in Perspective: The Last Mile
  11. Power BI and Tableau: Best Friends Forever
  12. Displaying Top N, Bottom N, and “All Others”
  13. New Twist for Dynamic Segmentation: Variable Grain Control
  14. 5 common mistakes made by self taught DAX students
  15. Mini-Post: Getting Ready for the Seattle Class Nov 11-12
  16. Insight Center: Azure-Based SharePoint / Power Pivot Server (Joint Solution with Microsoft)
  17. Power Pivot Job Opp in Washington DC Area
  18. SUM, SUMX or CALCULATE()…Choices, choices!
  19. In-Person Power Pivot Class in Seattle, Nov 11-12 Signups Open
  20. Excel to Power Pivot: Cross the Gap, Change the World
  21. Power Query Adds SalesForce Connectivity: Totally Awesome, But Trouble Looms Ahead
  22. Reminder: Live Class in Philly in < 2 Weeks
  23. How about a FIRSTDATE()?
  24. Blending “Time of Day” Analysis with Calendar/Date Analysis
  25. 5 Interactive Chart Techniques Come Together
  26. “I Know SQL Queries, So Why Do I Need Power Pivot?”
  27. Excel to Power Pivot: Cross the Gap workshop
  28. Aussie Aussie Aussie! Pivot Pivot Pivot!
  29. Leverage SharePoint for Rich User Interaction
  30. Preview of New Website Content
  31. Using SUMX on an IF statement–Call Center Example
  32. Tuesday Grab Bag of Biz and Fun
  33. Power BI: Natural Language Q&A–reality or hype?
  34. What is Power BI?
  35. The Benevolent Virus Spreads to Australia :)
  36. In-Person Class in Philly, Oct 21-22!