O que esperar para BI no SQL Server 2014

Fala galera, a alguns dias foi anunciado o CTP 1 do SQL Server 2014, e eu separei algumas funcionalidades interessantes relacionados à Business Intelligence que você poderá utilizar nesta nova versão.

Com certeza o SQL Server 2014 terá mais novidades do que estas que estou escrevendo aqui, mas já dá pra ter uma idéia do que vem por aí.

SYS.DM_EXEC_QUERY_PROFILES : Este código T-SQL não é exatamente relacionado à BI, mas nos ajudará a acompanhar em tempo real o progresso da consulta que está sendo executada. Uma aplicação pra essa consulta é entender em que ponto uma carga do Data Warehouse pode estar naquele exato momento.

Power View em Modelos Multidimensionais : Desde o Cumulative Update 4 do SQL Server 2012 com Service Pack 1 já é possível trabalhar com o Power View conectado em Modelos Multidimensionais. Sabemos que com o Excel 2013 o Power View já é nativo, mas no Excel ainda não suporta estas conexões multidimensionais. Para usufruir desta modelagem, é obrigatório o uso do SQL Server Reporting Services com SharePoint Mode. Por enquanto, só nesta configuração. Isso sem falar que esta nova release do Power View permite uma integração com mapas e gráficos de pizza.

Data Explorer para Excel : A algumas semanas tivemos o lançamento Data Explorer Preview, e conseguimos ter benefícios de identificar e importar dados de fontes externas não convencionais, como do HDFS (Hadoop Distributed File System), do Facebook e/ou de um site como o Wikipedia. Inclusive pode-se procurar por uma origem de dados dentro do seu “buscador”. No final, os dados são trazidos para dentro do Excel, ai o céu é o limite, divirta-se montando seus relatórios interativos com o Power View.

Geoflow para Excel : Também foi lançado a algumas semanas o Geoflow Preview, que permite uma criação em 3D de informações plotadas em um mapa geodesico (no formato do globo terrestre e não em formato planar) permitindo interagir mais naturalmente com os dados plotados, criando mapas de calor, gráficos de coluna ou de bolhas nas regiões que possuem determinada informação. Também é possível criar uma linha do tempo em cima daquele dado, porque podemos adicionar uma data e hora no dado e com poucos clicks comparar dois períodos. Por causa dessa timeline, também conseguimos criar estórias “cinematográficas” criando um tour guiado nos dados que queremos apresentar, mostrando evolução daquela informação.

Hekaton para In-Memory OLTP : O Hekaton é a estrutura para se trabalhar in-memory com o banco de dados relacional. Não é uma versão diferente do SQL Server, é só mais uma forma de se trabalhar com os dados e mudar o mind-set para um mundo onde não se tem concorrência, nem locks, muito menos dead-locks. Para se trabalhar com os dados em memória, você precisa definir que a tabela em questão terá esta peculiaridade, e então, ela passa a ser considerada como tal. Ok, isso também não tem nada a ver exclusivamente com BI, mas a partir do momento que está se montando o Data Warehouse e preparando os dados para o cubo OLAP processar, se isso acontecer mais rápido, teremos muitos benefícios.

ColumnStore Index permitindo escrita : Na versão 2012 do SQL Server, o ColumnStore Index foi lançado, mas por sua arquitetura, não era permitido escrever nas tabelas que possuiam este índex. Fiz um post comparando algumas formas de se escrever em tabelas com esta indexação. Agora no SQL Server 2014, o ColumnStore Index permitirá escrita nas tabelas. Esta indexação colunas continua sendo um grande benefício para trabalhar com Data Warehouse e também com cenários onde existam consultas com agregadores e muitos milhões de registros.

PowerPivot Management Dashboard : Esta ferramenta de gerenciamento está disponível no console de administração central do SharePoint 2013, possibilitando o monitoramento dos dados e das planilhas de Excel (publicadas no Excel Services do SharePoint) que estão sendo usadas. Permitindo tuning para melhorar a performance de um conjunto de dados específicos que são consumidos pelos nossos clientes através do portal.

Bom, como dito lá em cima, não são só estas novidades que temos para a stack de Business Intelligence no SQL Server 2014… Mas isso já dá uma boa idéia de coisas para se pesquisar e estudar nos próximos meses!

Compartilhe o post:
RSS
Follow by Email
Facebook
YOUTUBE
YOUTUBE
LinkedIn

Comentários

comments

About nogare

Diego Nogare é CDO - Chief Data Officer - na Lambda3, professor em programas de pós-graduação na Universidade Presbiteriana Mackenzie e na FIAP com disciplinas nas áreas de Inteligência Artificial, Big Data, Mineração de Dados, Machine Learning e Análise Estatística.

67 comments

  1. Hmm it seems like your website ate my first
    comment (it was extremely long) so I guess I’ll just sum it up what I had written and say, I’m thoroughly enjoying
    your blog. I too am an aspiring blog writer but I’m still new
    to everything. Do you have any tips for inexperienced blog writers?
    I’d certainly appreciate it.

  2. Odnośnie do ogólnych założeń, The Guild 3 nie odbiega za bardzo daleko od rozwiązań familiarnych z poprzednich odsłon partii
    i łączy w samemu elementy strategii ekonomicznej, symulatora
    życia i RPG-ów. W ogólności rzecz biorąc, rozgrywka
    ogniskuje się na rozwijaniu indywidualnego biznesu, co możemy zrobić na wiele różnych form, np.
    poprzez handel, dystans danej profesji i robienie rozmaitych przedmiotów, uczestniczenie przenigdy towarzyskim i politycznym zaś wchodzenie w interakcje spośród
    zamieszkującymi świat gry kondycjami niezależnymi.
    Podczas zabawy zdołamy też dołączać do przeróżnych gildii
    i stowarzyszeń – zarówno tych rzeczywistych (alchemików itp.
    ), jak i doskonale fikcyjnych. Otwiera nam owe
    dostęp do szerokiego spectrum specjalnych umiejętności, dzięki
    jakim możemy stopniowo rozwijać własną postać i minecraft do
    pobrania na bogate sposoby wpływać na losy otaczającego nas świata.
    1-dną z głównych zmian, opowiedzianych w trzeciej odsłonie sekwencji The Guild, jest stwierdzenie w
    stronę bardziej sandboksowej formuły rozgrywki.
    Zamiast zwartej linii fabularnej, w walce znajdziemy 12 zróżnicowanych zarysów, rozgrywających się na terenie wielu miast oraz ich stref.

    Naturalną konsekwencją owej sandboksowości jest także nacisk, który położono na sztuczną inteligencję komputerowych NPC-ów.
    Na gry opracowano zaawansowany system rządzący zachowaniami postaci niezależnych potrzeby, gry do
    pobraniajaki pozwala im analizować świat obiektywny i w
    odpowiedni modus na nią reagować. Projekt ów oparty został na sześciu przeciwstawnych wartościach, tudzież większość napotkanych postaci znajdować się może mieszankę różnych wyznawanych wartości.

    Odrębne moduły sztucznej inteligencji w grze skombinowały nie tylko pojedyncze postaci, atoli także rodziny, gildie
    azaliż miasta, a realizowane przy użyciu nich wzorce zachowań kwaszą zmianie na skutek posunięć gracza oraz innych zachodzących w
    świecie gry wydarzeń. W tym samym czasie stosunek bohatera do osobnych postaci czy grup społecznych w istotny
    sposób nagabuje na sam przebieg bitwy.

  3. Útil informação . Sorte me Descobri o site acidentalmente , e Eu sou
    surpreso por isto coincidência didn ‘ t aconteceu antecipadamente !
    Bookmarked-lo.

  4. I love hummingbird cake, and you can never beat a homey bundt cake with a luscious glaze! 15 days is going to go by fast — best of luck!
    cartier ring silver faux [url=http://www.amoregioielli.ru/en/imitation-cartier-yellow-gold-plated-love-ring-for-sale-p734/]cartier ring silver faux[/url]

  5. De cartao. Valeu, Augusto. Ao -me ԁe grande utilidade.

  6. Erɑ capaz dе encontrar boa informações de seu conteúdo.

  7. BJ7Uta I really thankful to find this internet site on bing, just what I was looking for also saved to fav.

  8. ᏞIKE WHᎪT DADDY, TELL US, TᎬLL US.? Both boys jumped
    up and down desirous to know easy methods to make God happy.

  9. Hi, Neat post. There is a problem with your web site in internet explorer, could test this?
    IE still is the marketplace leader and a large component to people will leave out your great writing because of this
    problem. http://www.astrodar.ru/?option=com_k2&view=itemlist&task=user&id=58267

  10. Hi, Neat post. There is a problem with your web site in internet explorer, could test this?
    IE still is the marketplace leader and a large component to
    people will leave out your great writing because of this problem. http://www.astrodar.ru/?option=com_k2&view=itemlist&task=user&id=58267

  11. Excellent blog you’ve got here.. It’s hard to find good quality writing
    like yours nowadays. I truly appreciate people like you!
    Take care!! http://wtsusa.us/component/k2/itemlist/user/68994

  12. Good web site you have here.. It?s difficult to
    find high quality writing like yours these days. I honestly appreciate people like you!

    Take care!!

  13. While a number of volcanoes in Bali are active, many of them have erupted in the recent past and
    which attract a large number of tourists every year to Bali.
    From this can made sure that your Southeast
    Asia travel in Laos can be a memorable one which you will remember through out your life.
    In ancient Rome, it was a sign for good luck and that meaning has survived in Portugal and Brazil.

  14. Hello! I’ve been reading your weblog for some time now and
    finally got the bravery to go ahead and give you
    a shout out from Dallas Texas! Just wanted to say keep up the great
    job! http://teknisikomputer.com/index.php/component/k2/itemlist/user/947

  15. I was reading through some of your blog posts on this site and I conceive this web site is really informative ! Keep putting up.

  16. Microsoft’s Windows Live Hotmail allows one to permanently disable old accounts in case you no longer wish to work
    with them. It is used by people to contact their families, friends, relatives and business contacts.

  17. In Friday’s unscheduled assertion ahead of full outcomes due on March 5,
    Adidas reported 2014 gross sales up 2 p.c to 14.8 billion euros (11.22 billion kilos), beating a Thomson Reuters Smart Estimate of 14.68 billion euros.

  18. I don’t know if it’s just me or if perhaps everyone else encountering issues with your website.
    It appears like some of the written text in your content are running off the screen. Can somebody else please
    comment and let me know if this is happening to them as well?
    This could be a problem with my web browser because I’ve
    had this happen previously. Many thankswholesale mlb jerseys free shipping

  19. Health experts advise to purchase sports activities shoe from renowned manufacturers and select the shoe in response
    to your foot kind.

  20. Wow, fantastic blog format! How lengthy have you ever been running a blog for?
    you made running a blog glance easy. The total look of your website is excellent, as well as the content material!

    wholesale authentic jerseys

  21. Astounding write-up! I hugely enjoy your work!

  22. I do trust all of the ideas you have presented on your post.
    They’re very convincing and will certainly work. Nonetheless, the posts are very short for beginners.
    May just you please prolong them a bit from next time? Thanks for the post.

  23. The nike jordan sports activities for the occasions maximum skilled sports activities gear goes to be purposeful
    for the happening and sports belongings improvement to produce a big assist.

  24. Thanks for the marvelous posting! I really enjoyed reading it, you might be
    a great author.I will ensure that I bookmark your blog and will often come
    back in the future. I want to encourage continue your great writing, have a nice evening! http://g6.world/index.php/component/k2/itemlist/user/183643

  25. It is possible to achieve the goals in the game working with
    the Pixel Gun 3D hack tool and you are also notified for the
    newest updates or variations, which you can just download through the respective site.

  26. I visited various websites except the audio feature for audio songs present at this web site is truly fabulous.

  27. Gondola shelves are extremely sturdy and extended-lasting.

  28. Definitely believe that which you stated. Your favorite reason appeared to be on the web the easiest thing
    to be aware of. I say to you, I definitely get irked while people consider
    worries that they just don’t know about. You managed to hit the nail
    upon the top as well as defined out the whole thing without having side effect ,
    people can take a signal. Will probably be back to
    get more. Thanks

  29. Skechers is over 5 instances the dimensions of Heelys in terms of market capitalization.

  30. I think that what you composed made a ton of sense.

    But, what about this? suppose you added a
    little content? I am not suggesting your content isn’t
    solid, however suppose you added something to possibly grab folk’s attention? I mean O que esperar
    para BI no SQL Server 2014 – Think Think SQL is a
    little plain. You ought to glance at Yahoo’s front page and note how they write news headlines
    to get viewers to open the links. You might try adding a
    video or a related pic or two to get people interested about everything’ve written. Just my opinion, it would bring your website
    a little livelier.

  31. Ahaa, its fastidious dialogue concerning this article at this place at this
    weblog, I have read all that, so at this time me also commenting at this place.

  32. We’re a gaggle of volunteers and starting a new scheme
    in our community. Your web site offered us with helpful info to work on. You’ve done
    an impressive job and our whole group will likely be
    thankful to you.

  33. After study several of the blogs on your website now, and I really like
    your way of operating a blog. I bookmarked it
    to my bookmark website list and will be checking back soon. Pls take a look
    at my web site as well and let me know your opinion.

  34. Yes! Finally someone writes about captcha bypass service.

  35. My brother recommended I may like this blog. He used to be totally right.
    This post actually made my day. You can not
    believe simply how so much time I had spent for this info!
    Thanks!

  36. I have been exploring for a little for any high-quality articles or weblog posts in this kind of house .
    Exploring in Yahoo I finally stumbled upon this website.
    Studying this info So i’m glad to show that I’ve a very excellent uncanny
    feeling I found out exactly what I needed. I most no doubt will make sure to
    do not overlook this site and give it a glance regularly.

  37. Show your Goods Free now! Take a appear!

  38. I truly love your website.. Very nice colors & theme.
    Did you create this site yourself? Please reply back as I’m attempting to create my
    very own site and would like to know where you got this
    from or just what the theme is named. Many thanks!

  39. When someone writes an article he/she keeps the thought of
    a user in his/her mind that how a user can understand it. Thus that’s why
    this post is outstdanding. Thanks!

  40. This design is wicked! You certainly know how
    to keep a reader entertained. Between your wit and your videos, I was
    almost moved to start my own blog (well, almost…HaHa!) Fantastic job.
    I really loved what you had to say, and more
    than that, how you presented it. Too cool!

  41. Thanks for sharing your thoughts on xarelto lawsuit.
    Regards

  42. If you wish for to obtain much from this article then you have to apply such strategies to your won website.

  43. Where can I buy over the counter in south africa http://www.brandssolution.co.uk/uploads/160_120/pharmacy/locin.html generic next day delivery uk.

  44. This is really interesting, You’re a very skilled blogger.
    I’ve joined your rss feed and look forward to seeking more of
    your great post. Also, I have shared your website in my social networks!

  45. Hi there! This is my first visit to your blog!
    We are a collection of volunteers and starting a new initiative in a community in the same niche.
    Your blog provided us useful information to work on.
    You have done a extraordinary job!

  46. Greetings! Very helpful advice in this particular article!

    It’s the little changes which will make the largest changes.

    Thanks for sharing!

  47. SUPER MEGA KIT WHATSAPP MARKETING

    Alcance Seu Publico Alvo

    Pedidos Na Area De Contatos

    SITE: http://bit.ly/2djAmSJ

    Whatsapp: (11)98197-6653

  48. Hello, I do believe your blog could be having web browser compatibility problems.

    When I look at your site in Safari, it looks fine
    but when opening in I.E., it has some overlapping issues. I simply wanted to provide you with
    a quick heads up! Aside from that, great site!

  49. This is the highest paying free bitcoin app available.

  50. Maybe you cannot be a famous director; you’ll be able
    to still direct a movie to memorize your life. Excellent teachers are in demand and
    usually have a lot of students. For the Dalai Lama, the spiritual
    leader from the Gelug sect of Tibetan Buddhism, to be
    so thought to be essentially the most influential person with the year within the western world is a perfect example of the respect we
    should all show toward other religions and the acceptance of
    views that do not always mirror our own.

  51. I always used to read paragraph in news papers but now as I
    am a user of net thus from now I am using net for content, thanks to web.

  52. I positively liked the whole kit that was written.
    I’d love to keep reading more and more.
    I liking be jubilant to learn as much as I can
    I surely admire you in behalf of the issue so well done thank you unusually much to save the time. Successfully!

  53. I simply want to mention I am just very new to blogging and really savored you’re blog site. Very likely I’m want to bookmark your blog post . You surely come with wonderful writings. Regards for sharing with us your web-site.

  54. Предположим, вы собственник нового интернет-сайта, который имеет приятный стиль, удобную навигацию и нужную для гостей рекламную информацию. Но интернет-сервис ни кто не посещает. Что делать? Если у вас есть собственный бизнес мы поможем вам создать лендинг. Как известно, ни одно настоящее либо виртуальное предприятие не может продвигаться независимо. Каждой фирме необходимо поддержка в приобретении популярности, а во Всемирной сети без нее категорически не обойтись из-за яростной конкурентной борьбы.Мы занимаемся разработкой порталов. Сотрудники нашей компании готовы запустить настоящий проект в течение десяти рабочих дней. Вдобавок выдачи отделанных online-проектов, мы выполняем такие услуги как тех. службы: уместное продление хостинга и нового домена, добавление контента на веб-сайт, публикация известий. Наши услуги помогут вам стать фаворитом на горизонтах всемирной паутины.

    продвижение сайта в сша

  55. Great goods from you, man. I have understand your stuff
    previous to and you’re just too great. I really like what you have acquired here, certainly like what
    you’re stating and the way in which you say it. You make it entertaining and you still care for
    to keep it wise. I can not wait to read far more from you.
    This is really a tremendous website.

  1. Pingback: Google

  2. Pingback: auto taxi

Deixe uma resposta

O seu endereço de e-mail não será publicado.