Narciso Robles

32 Flips | 15 Magazines | 28 Likes | @NarcisoRobl2015 | Keep up with Narciso Robles on Flipboard, a place to see the stories, photos, and updates that matter to you. Flipboard creates a personalized magazine full of everything, from world news to life’s great moments. Download Flipboard for free and search for “Narciso Robles”

SQL Server DateTime Best Practices

By: Aaron Bertrand | Read Comments (3) | Related Tips: More > Dates<p>Problem<p>Dealing with date and time data in SQL Server can be tricky. I see a …

5 EASY WAYS TO FIND GREAT STORIES IN YOUR DATA

<i>This article originally appeared on Column Five.</i><p>Data storytelling is one of the best tools out there for content marketers. But for data noobs it can …

Handy Python Libraries for Formatting and Cleaning Data

The real world is messy, and so too is its data. So messy, that a recent survey reported data scientists spend 60% of their time cleaning data. …

Everything you need to know about regression models in Python

<i>Python is a very versatile piece of software. It offers many choices for Web applications and can be used in thousands of third party modules. Python</i> …

Python Programming

How to Program: Computer Science Concepts and Python Exercises

What Is Programming? Why Python?<p>episode 130 min.<p>Hello, World! Following tradition, write a program that produces this greeting as your first exercise …

Scikit-Learn Cheat Sheet: Python Machine Learning

Python For Data Science Cheat Sheet: Scikit-learn<p>Scikit-learn is an open source Python library that implements a range of machine learning, …

PivotTables, Percentages, and Cumulative Percentages

Introduction<p>For those who build PivotTables in Excel, basic computations such as summing large volumes of data rarely present challenges. However, …

Use Slicers for Query Parameters in PowerBI

Reading Rob Collie’s latest cool blogpost on how to retrieve slicer selections in Power BI, I couldn’t stop thinking of how awesome it would be, if …

Progress Doughnut Chart with Conditional Formatting in Excel

<b>Bottom line:</b> Learn how to create a progress doughnut chart or circle chart in Excel. This chart displays a progress bar with the percentage of …

Comparison graphs reveal the real story: Which visualisation is most effective?

Graphs are incredible tools for data visualisation, and form part of the fundamental process of comparing data to target goals in order to reveal …

DAX Time Intelligence Explained

<i>Level: Beginners</i><p>I help a lot of people on forums who ask questions about time intelligence for DAX. If you are just starting out then the chances are …

Analytics

The IN operator in DAX

This article describes the IN operator in DAX, which simplifies logical conditions checking whether a certain value is included in a list of values …

Databases

Kill NULLs – a Simple macro to save time when importing data from SQL Server

As part of a my ongoing consulting gig, I often run painfully long queries on SQL Server to fetch data. This data <i>obviously</i> ends up in Excel for …

SyntaxDB - A programming syntax 'search engine' made to order for programmers

SyntaxDB — Made To Order Programming Syntax “Search Engine” For Programmers<p>While Google has answers to any query under the Sun, it fails miserably …

Programming

Working with Inline Tables and Using IN Operator in Filter

It’s is often handy to be able to define a table in line with your calculation. Apparently, you can do it in DAX using the following syntax:<b>{ value1,</b> …

Power BI Skills - Thinking of Data in Tables

<i>Level: Beginners</i><p>One very important concept that Excel users often struggle with when starting on their Power BI and Power Pivot journey is that <b>they</b> …

Databases

Trump’s Address to Congress

SummaryIn his first address to a joint session of Congress, President Donald Trump stuck closely to his prepared remarks, but ran afoul of the facts …

Create Dynamic Query Parameters in Power BI Desktop - Power BI Tips & Tricks #47

Power BI

Data mining your general ledger with Excel

The general ledger is a vast historical data archive of your company's financial activities, including revenue, expenses, adjustments, account …

Column Renaming and List.Zip To The Rescue - Pitfall #6 in #PowerBI #PowerQuery

Today, we will learn how to avoid the 6th pitfall as part of the Power BI / Power Query Pitfalls series. The sixth pitfall is quite tricky, and is …

Disproportionately Popular & Unpopular Outliers by Region, Demographic, etc.

<i>(Image Courtesy of</i> <i>Orbitz.com</i><i>)</i><b>Disproportionately Popular International Destinations by US State – Can We Do Something Similar?</b>Inspiration Strikes!<b>I</b> …

Variables: learn programming in Python - The MagPi Magazine

If you’ve created a science project or experiment, you may have come across variables. In science, a variable is any factor that you can control, …

Python Programming

Solving Business Problems – Power Query Does That

<i>This week's blog post on solving business problems with Power Query is a guest post by Alex Jankowski</i>Does your business or work group have manual …

What to expect when you are expecting (from volunteers, that is)

<b>You can measure some pretty high expectations from volunteers – IF you market to the ones who will deliver</b><p>I hear a lot about how the paradigm is …

2 Steps to Add a Watermark to Outlook Email Messages - Data Recovery Blog

<i>As we all know, MS Word permits users to add watermark to the document, but Outlook cannot. In fact, by means of Word and Paint, we can add watermark</i> …

2 Simple Tricks for Manipulating Word Tables that Extend Beyond a Page - Data Recovery Blog

<i>Sometimes your Word document may contain large tables that span multiple pages. To cope with these tables, our article will introduce 2 useful tricks</i> …

The Trick That Turns Your Grill Into a Top-Notch Smoker

It's called the snake method, and it's free!<p>They say that a great charcoal grill is just a so-so smoker. But do you really need to buy a $600 smoker to give your brisket the delectable flavor you seek? Weber's all-in-one chef, cookbook author, and food blogger Jamie Purviance says you don't have to …

Cooking

Excel Worksheets Tutorial: VBA Activesheet vs Worksheets

Today we are going to learn about VBA Worksheets. We will cover all the nuisances e.g. <b>VBA Activesheet and how it compares to regular Worksheets</b>, how …